Data Manipulation Language
By jamiecchavez
Explore what DML is including its main commands INSERT, UPDATE, DELETE, and SELECT.
Referential Integrity
Explore what referential integrity is, why it's important to reliable data organization, and learn how it enforces constraints.
Database Naming Conventions
In this learning activity, you'll discover and then follow established rules when naming database objects.
What is Database Denormalization?
In this activity, the learner will understand what denormalization is and when it's an appropriate strategy.
Database Data Types
In this activity, you'll learn about the different data types associated with databases.
JOINs (Inner, Left, Right, Full)
In this learning activity, you’ll explore four different types of JOINs and understand how they help programmers produce readable reports.
Normalization – 3rd Normal Form
In this learning activity, you'll be introduced to Third Normal Form and you'll design a table following these rules.
Normalization – 2nd Normal Form
In this activity you'll practice designing a table in second normal form.
What Is Normalization?
In this learning activity you'll examine how database normalization eliminates redundancy and helps maintain consistency within a relational database.
Normalization – 1st Normal Form
In this learning activity you'll explore and practice the first step in normalizing a database.
In this activity, you will learn how to assign the correct data type to the the listed data element. Let's play ball!
You'll be challenged to identify various database field types.
You'll be introduced to several basic SQL commands used to manage databases.
Match the T-SQL data type with the correct and/or maximum data value.